import pandas as pd
list = [[110, 120, 105], [95, 110, 108], [98, 80, 100], [112, 106, 97]]
index =['王蒙', '李珊', '赵胜', '刘文']
columns = ['语文', '数学', '英语']
df = pd.DataFrame(list, index, columns)
print('保存到“scorel” 工作表中的数据: \n', df)
writer = pd.ExcelWriter('Score.xlsx')
df.to_excel(writer, sheet_name='scorel')
df.iloc[0] = [105, 118, 100]
print('保存到“score2” 工作表中的数据: \n', df)
df.to_excel(writer, sheet_name='score2')
writer.save()
df1=pd.read_excel('Score.xlsx', sheet_name=['Score1', 'score2'],index_col=0)
print('导入·的数据: \n', df1)
